﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Names = Citi.PTSConsolidation.Domain.EntrepotDatabaseNames.Application;

namespace Citi.PTSConsolidation.Domain
{
    public class Application
    {
        #region Mappings

        public static readonly Dictionary<string, string> ColumnMappings = new Dictionary<string, string>
        {
            {Names.Id, "Id"},
            {Names.Name, "Name"},
            {Names.RetirementDate, "RetirementDate"}
        };

        #endregion

        #region Querystrings

        public static string EntrepotQueryString = string.Format(@"select {0}, {1}, {2} from {3}", Names.Id, Names.Name, Names.RetirementDate, Names.TableName);

        public const string QueryDuplicateData = "DELETE FROM Application";

        #endregion
    }
}
